Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 844392 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 120.0 MiB |
| Average record size in memory | 149.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Categorical | 9 |
Promo2SinceWeek is highly correlated with Promo2 and 2 other fields | High correlation |
Promo2SinceYear is highly correlated with Promo2 and 2 other fields | High correlation |
Month is highly correlated with SchoolHoliday and 2 other fields | High correlation |
WeekOfYear is highly correlated with Season and 1 other fields | High correlation |
StoreType is highly correlated with Assortment | High correlation |
Assortment is highly correlated with StoreType | High correlation |
Promo2 is highly correlated with Promo2SinceWeek and 2 other fields | High correlation |
PromoInterval is highly correlated with Promo2 and 2 other fields | High correlation |
Season is highly correlated with Month and 1 other fields | High correlation |
SchoolHoliday is highly correlated with Month | High correlation |
Reproduction
| Analysis started | 2022-11-28 17:13:02.312789 |
|---|---|
| Analysis finished | 2022-11-28 17:14:06.114809 |
| Duration | 1 minute and 3.8 seconds |
| Software version | pandas-profiling v3.4.0 |
| Download configuration | config.json |
Store
Real number (ℝ≥0)
| Distinct | 1115 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 558.4229197 |
| Minimum | 1 |
|---|---|
| Maximum | 1115 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 56 |
| Q1 | 280 |
| median | 558 |
| Q3 | 837 |
| 95-th percentile | 1060 |
| Maximum | 1115 |
| Range | 1114 |
| Interquartile range (IQR) | 557 |
Descriptive statistics
| Standard deviation | 321.7319144 |
|---|---|
| Coefficient of variation (CV) | 0.5761438205 |
| Kurtosis | -1.198841375 |
| Mean | 558.4229197 |
| Median Absolute Deviation (MAD) | 278 |
| Skewness | 0.0004137544558 |
| Sum | 471527846 |
| Variance | 103511.4247 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 769 | 942 | 0.1% |
| 1097 | 942 | 0.1% |
| 85 | 942 | 0.1% |
| 562 | 942 | 0.1% |
| 262 | 942 | 0.1% |
| 733 | 942 | 0.1% |
| 494 | 942 | 0.1% |
| 682 | 942 | 0.1% |
| 335 | 942 | 0.1% |
| 423 | 942 | 0.1% |
| Other values (1105) | 834972 |
| Value | Count | Frequency (%) |
| 1 | 781 | |
| 2 | 784 | |
| 3 | 779 | |
| 4 | 784 | |
| 5 | 779 | |
| 6 | 780 | |
| 7 | 786 | |
| 8 | 784 | |
| 9 | 779 | |
| 10 | 784 |
| Value | Count | Frequency (%) |
| 1115 | 781 | |
| 1114 | 784 | |
| 1113 | 784 | |
| 1112 | 779 | |
| 1111 | 779 | |
| 1110 | 783 | |
| 1109 | 622 | |
| 1108 | 780 | |
| 1107 | 623 | |
| 1106 | 784 |
DayOfWeek
Real number (ℝ≥0)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.520361396 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.723689221 |
|---|---|
| Coefficient of variation (CV) | 0.4896341674 |
| Kurtosis | -1.259310053 |
| Mean | 3.520361396 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.01929954019 |
| Sum | 2972565 |
| Variance | 2.971104532 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 6 | 144058 | |
| 2 | 143961 | |
| 3 | 141936 | |
| 5 | 138640 | |
| 1 | 137560 | |
| 4 | 134644 | |
| 7 | 3593 | 0.4% |
| Value | Count | Frequency (%) |
| 1 | 137560 | |
| 2 | 143961 | |
| 3 | 141936 | |
| 4 | 134644 | |
| 5 | 138640 | |
| 6 | 144058 | |
| 7 | 3593 | 0.4% |
| Value | Count | Frequency (%) |
| 7 | 3593 | 0.4% |
| 6 | 144058 | |
| 5 | 138640 | |
| 4 | 134644 | |
| 3 | 141936 | |
| 2 | 143961 | |
| 1 | 137560 |
Sales
Real number (ℝ≥0)
| Distinct | 21734 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6955.514291 |
| Minimum | 0 |
|---|---|
| Maximum | 41551 |
| Zeros | 54 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3173 |
| Q1 | 4859 |
| median | 6369 |
| Q3 | 8360 |
| 95-th percentile | 12668 |
| Maximum | 41551 |
| Range | 41551 |
| Interquartile range (IQR) | 3501 |
Descriptive statistics
| Standard deviation | 3104.21468 |
|---|---|
| Coefficient of variation (CV) | 0.4462954931 |
| Kurtosis | 4.852011543 |
| Mean | 6955.514291 |
| Median Absolute Deviation (MAD) | 1694 |
| Skewness | 1.593922039 |
| Sum | 5873180623 |
| Variance | 9636148.782 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5674 | 215 | < 0.1% |
| 5558 | 197 | < 0.1% |
| 5483 | 196 | < 0.1% |
| 6214 | 195 | < 0.1% |
| 6049 | 195 | < 0.1% |
| 5723 | 194 | < 0.1% |
| 5449 | 192 | < 0.1% |
| 5140 | 191 | < 0.1% |
| 5489 | 191 | < 0.1% |
| 5041 | 190 | < 0.1% |
| Other values (21724) | 842436 |
| Value | Count | Frequency (%) |
| 0 | 54 | |
| 46 | 1 | < 0.1% |
| 124 | 1 | < 0.1% |
| 133 | 1 | < 0.1% |
| 286 | 1 | < 0.1% |
| 297 | 1 | < 0.1% |
| 316 | 1 | < 0.1% |
| 416 | 1 | < 0.1% |
| 506 | 1 | < 0.1% |
| 520 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 41551 | 1 | |
| 38722 | 1 | |
| 38484 | 1 | |
| 38367 | 1 | |
| 38037 | 1 | |
| 38025 | 1 | |
| 37646 | 1 | |
| 37403 | 1 | |
| 37376 | 1 | |
| 37122 | 1 |
Promo
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.4 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 467496 | |
| 1 | 376896 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 467496 | |
| 1 | 376896 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 467496 | |
| 1 | 376896 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 844392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 467496 | |
| 1 | 376896 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 844392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 467496 | |
| 1 | 376896 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 467496 | |
| 1 | 376896 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.4 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 680935 | |
| 1 | 163457 | 19.4% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 680935 | |
| 1 | 163457 | 19.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 680935 | |
| 1 | 163457 | 19.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 844392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 680935 | |
| 1 | 163457 | 19.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 844392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 680935 | |
| 1 | 163457 | 19.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 680935 | |
| 1 | 163457 | 19.4% |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.4 MiB |
| 1 | |
|---|---|
| 4 | |
| 3 | |
| 2 | 15563 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 3 |
| 3rd row | 3 |
| 4th row | 3 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 457077 | |
| 4 | 258774 | |
| 3 | 112978 | 13.4% |
| 2 | 15563 | 1.8% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 1 | 457077 | |
| 4 | 258774 | |
| 3 | 112978 | 13.4% |
| 2 | 15563 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 457077 | |
| 4 | 258774 | |
| 3 | 112978 | 13.4% |
| 2 | 15563 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 844392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 457077 | |
| 4 | 258774 | |
| 3 | 112978 | 13.4% |
| 2 | 15563 | 1.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 844392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 457077 | |
| 4 | 258774 | |
| 3 | 112978 | 13.4% |
| 2 | 15563 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 457077 | |
| 4 | 258774 | |
| 3 | 112978 | 13.4% |
| 2 | 15563 | 1.8% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.4 MiB |
| 1 | |
|---|---|
| 3 | |
| 2 | 8212 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 444909 | |
| 3 | 391271 | |
| 2 | 8212 | 1.0% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 1 | 444909 | |
| 3 | 391271 | |
| 2 | 8212 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 444909 | |
| 3 | 391271 | |
| 2 | 8212 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 844392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 444909 | |
| 3 | 391271 | |
| 2 | 8212 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 844392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 444909 | |
| 3 | 391271 | |
| 2 | 8212 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 444909 | |
| 3 | 391271 | |
| 2 | 8212 | 1.0% |
CompetitionDistance
Real number (ℝ≥0)
| Distinct | 655 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5457.842215 |
| Minimum | 20 |
|---|---|
| Maximum | 75860 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 130 |
| Q1 | 710 |
| median | 2330 |
| Q3 | 6880 |
| 95-th percentile | 20390 |
| Maximum | 75860 |
| Range | 75840 |
| Interquartile range (IQR) | 6170 |
Descriptive statistics
| Standard deviation | 7799.322503 |
|---|---|
| Coefficient of variation (CV) | 1.429012089 |
| Kurtosis | 13.45618862 |
| Mean | 5457.842215 |
| Median Absolute Deviation (MAD) | 1980 |
| Skewness | 2.97902141 |
| Sum | 4608558304 |
| Variance | 60829431.51 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 250 | 9210 | 1.1% |
| 50 | 6249 | 0.7% |
| 350 | 6239 | 0.7% |
| 1200 | 6072 | 0.7% |
| 190 | 6066 | 0.7% |
| 90 | 5609 | 0.7% |
| 180 | 5422 | 0.6% |
| 150 | 5294 | 0.6% |
| 330 | 5294 | 0.6% |
| 140 | 4684 | 0.6% |
| Other values (645) | 784253 |
| Value | Count | Frequency (%) |
| 20 | 779 | 0.1% |
| 30 | 3116 | |
| 40 | 3890 | |
| 50 | 6249 | |
| 60 | 2342 | 0.3% |
| 70 | 3736 | |
| 80 | 2331 | 0.3% |
| 90 | 5609 | |
| 100 | 3900 | |
| 110 | 4516 |
| Value | Count | Frequency (%) |
| 75860 | 887 | |
| 58260 | 885 | |
| 48330 | 784 | |
| 46590 | 784 | |
| 45740 | 780 | |
| 44320 | 780 | |
| 40860 | 881 | |
| 40540 | 780 | |
| 38710 | 784 | |
| 38630 | 882 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.4 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 421085 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 421085 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 421085 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 844392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 421085 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 844392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 421085 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 421085 |
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.12637969 |
| Minimum | 1 |
|---|---|
| Maximum | 50 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 22 |
| median | 23 |
| Q3 | 23 |
| 95-th percentile | 40 |
| Maximum | 50 |
| Range | 49 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 9.958280574 |
|---|---|
| Coefficient of variation (CV) | 0.4306026584 |
| Kurtosis | 0.2780491106 |
| Mean | 23.12637969 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.188918715 |
| Sum | 19527730 |
| Variance | 99.16735199 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 23 | 426865 | |
| 14 | 60541 | 7.2% |
| 40 | 51507 | 6.1% |
| 31 | 33238 | 3.9% |
| 10 | 32214 | 3.8% |
| 5 | 29722 | 3.5% |
| 37 | 27116 | 3.2% |
| 1 | 26873 | 3.2% |
| 13 | 24579 | 2.9% |
| 45 | 24072 | 2.9% |
| Other values (14) | 107665 | 12.8% |
| Value | Count | Frequency (%) |
| 1 | 26873 | 3.2% |
| 5 | 29722 | 3.5% |
| 6 | 771 | 0.1% |
| 9 | 10293 | 1.2% |
| 10 | 32214 | 3.8% |
| 13 | 24579 | 2.9% |
| 14 | 60541 | 7.2% |
| 18 | 22456 | 2.7% |
| 22 | 23645 | 2.8% |
| 23 | 426865 |
| Value | Count | Frequency (%) |
| 50 | 780 | 0.1% |
| 49 | 622 | 0.1% |
| 48 | 7033 | 0.8% |
| 45 | 24072 | |
| 44 | 2182 | 0.3% |
| 40 | 51507 | |
| 39 | 3889 | 0.5% |
| 37 | 27116 | |
| 36 | 7620 | 0.9% |
| 35 | 18888 | 2.2% |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2011.376017 |
| Minimum | 2009 |
|---|---|
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 2009 |
|---|---|
| 5-th percentile | 2009 |
| Q1 | 2011 |
| median | 2011 |
| Q3 | 2012 |
| 95-th percentile | 2014 |
| Maximum | 2015 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.232031398 |
|---|---|
| Coefficient of variation (CV) | 0.0006125316137 |
| Kurtosis | 0.5693643536 |
| Mean | 2011.376017 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.6844175859 |
| Sum | 1698389818 |
| Variance | 1.517901365 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 2011 | 518347 | |
| 2013 | 91866 | 10.9% |
| 2014 | 65768 | 7.8% |
| 2012 | 60716 | 7.2% |
| 2009 | 53826 | 6.4% |
| 2010 | 46414 | 5.5% |
| 2015 | 7455 | 0.9% |
| Value | Count | Frequency (%) |
| 2009 | 53826 | 6.4% |
| 2010 | 46414 | 5.5% |
| 2011 | 518347 | |
| 2012 | 60716 | 7.2% |
| 2013 | 91866 | 10.9% |
| 2014 | 65768 | 7.8% |
| 2015 | 7455 | 0.9% |
| Value | Count | Frequency (%) |
| 2015 | 7455 | 0.9% |
| 2014 | 65768 | 7.8% |
| 2013 | 91866 | 10.9% |
| 2012 | 60716 | 7.2% |
| 2011 | 518347 | |
| 2010 | 46414 | 5.5% |
| 2009 | 53826 | 6.4% |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.4 MiB |
| 0 | |
|---|---|
| 1 | |
| 2 | |
| 3 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 242411 | |
| 2 | 98005 | 11.6% |
| 3 | 80669 | 9.6% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 242411 | |
| 2 | 98005 | 11.6% |
| 3 | 80669 | 9.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 242411 | |
| 2 | 98005 | 11.6% |
| 3 | 80669 | 9.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 844392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 242411 | |
| 2 | 98005 | 11.6% |
| 3 | 80669 | 9.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 844392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 242411 | |
| 2 | 98005 | 11.6% |
| 3 | 80669 | 9.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 423307 | |
| 1 | 242411 | |
| 2 | 98005 | 11.6% |
| 3 | 80669 | 9.6% |
CompetitionOpenSinceMonth
Real number (ℝ)
| Distinct | 376 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 63.89704782 |
| Minimum | -32 |
|---|---|
| Maximum | 1407 |
| Zeros | 4524 |
| Zeros (%) | 0.5% |
| Negative | 70108 |
| Negative (%) | 8.3% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | -32 |
|---|---|
| 5-th percentile | -7 |
| Q1 | 30 |
| median | 64 |
| Q3 | 83 |
| 95-th percentile | 145 |
| Maximum | 1407 |
| Range | 1439 |
| Interquartile range (IQR) | 53 |
Descriptive statistics
| Standard deviation | 60.80793108 |
|---|---|
| Coefficient of variation (CV) | 0.9516547815 |
| Kurtosis | 172.6376179 |
| Mean | 63.89704782 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | 8.734165744 |
| Sum | 53954156 |
| Variance | 3697.604482 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 56 | 12695 | 1.5% |
| 60 | 12693 | 1.5% |
| 63 | 12690 | 1.5% |
| 61 | 12625 | 1.5% |
| 68 | 12561 | 1.5% |
| 65 | 12434 | 1.5% |
| 69 | 12332 | 1.5% |
| 81 | 12326 | 1.5% |
| 80 | 12296 | 1.5% |
| 62 | 12259 | 1.5% |
| Other values (366) | 719481 |
| Value | Count | Frequency (%) |
| -32 | 30 | < 0.1% |
| -31 | 147 | < 0.1% |
| -30 | 323 | < 0.1% |
| -29 | 445 | 0.1% |
| -28 | 593 | |
| -27 | 772 | |
| -26 | 853 | |
| -25 | 896 | |
| -24 | 976 | |
| -23 | 1139 |
| Value | Count | Frequency (%) |
| 1407 | 5 | < 0.1% |
| 1406 | 25 | |
| 1405 | 25 | |
| 1404 | 23 | |
| 1403 | 23 | |
| 1402 | 26 | |
| 1401 | 26 | |
| 1400 | 21 | |
| 1393 | 23 | |
| 1392 | 24 |
Year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.4 MiB |
| 2013 | |
|---|---|
| 2014 | |
| 2015 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 3377568 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2015 |
|---|---|
| 2nd row | 2015 |
| 3rd row | 2015 |
| 4th row | 2015 |
| 5th row | 2015 |
Common Values
| Value | Count | Frequency (%) |
| 2013 | 337943 | |
| 2014 | 310417 | |
| 2015 | 196032 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 2013 | 337943 | |
| 2014 | 310417 | |
| 2015 | 196032 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 844392 | |
| 0 | 844392 | |
| 1 | 844392 | |
| 3 | 337943 | |
| 4 | 310417 | 9.2% |
| 5 | 196032 | 5.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3377568 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 844392 | |
| 0 | 844392 | |
| 1 | 844392 | |
| 3 | 337943 | |
| 4 | 310417 | 9.2% |
| 5 | 196032 | 5.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3377568 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 844392 | |
| 0 | 844392 | |
| 1 | 844392 | |
| 3 | 337943 | |
| 4 | 310417 | 9.2% |
| 5 | 196032 | 5.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3377568 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 844392 | |
| 0 | 844392 | |
| 1 | 844392 | |
| 3 | 337943 | |
| 4 | 310417 | 9.2% |
| 5 | 196032 | 5.8% |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.4 MiB |
| 2 | |
|---|---|
| 3 | |
| 1 | |
| 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 3 |
| 3rd row | 3 |
| 4th row | 3 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 247814 | |
| 3 | 222576 | |
| 1 | 216979 | |
| 4 | 157023 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 2 | 247814 | |
| 3 | 222576 | |
| 1 | 216979 | |
| 4 | 157023 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 247814 | |
| 3 | 222576 | |
| 1 | 216979 | |
| 4 | 157023 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 844392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 247814 | |
| 3 | 222576 | |
| 1 | 216979 | |
| 4 | 157023 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 844392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 247814 | |
| 3 | 222576 | |
| 1 | 216979 | |
| 4 | 157023 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 247814 | |
| 3 | 222576 | |
| 1 | 216979 | |
| 4 | 157023 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.845737525 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.32393127 |
|---|---|
| Coefficient of variation (CV) | 0.568607683 |
| Kurtosis | -1.033170522 |
| Mean | 5.845737525 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.2577004047 |
| Sum | 4936094 |
| Variance | 11.04851908 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 1 | 86343 | |
| 3 | 85980 | |
| 7 | 85587 | |
| 6 | 82576 | |
| 4 | 81731 | |
| 2 | 80243 | |
| 5 | 80103 | |
| 8 | 54413 | |
| 10 | 53292 | |
| 9 | 52330 | |
| Other values (2) | 101794 |
| Value | Count | Frequency (%) |
| 1 | 86343 | |
| 2 | 80243 | |
| 3 | 85980 | |
| 4 | 81731 | |
| 5 | 80103 | |
| 6 | 82576 | |
| 7 | 85587 | |
| 8 | 54413 | |
| 9 | 52330 | |
| 10 | 53292 |
| Value | Count | Frequency (%) |
| 12 | 50393 | |
| 11 | 51401 | |
| 10 | 53292 | |
| 9 | 52330 | |
| 8 | 54413 | |
| 7 | 85587 | |
| 6 | 82576 | |
| 5 | 80103 | |
| 4 | 81731 | |
| 3 | 85980 |
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.64680149 |
| Minimum | 1 |
|---|---|
| Maximum | 52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 11 |
| median | 23 |
| Q3 | 35 |
| 95-th percentile | 49 |
| Maximum | 52 |
| Range | 51 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 14.389785 |
|---|---|
| Coefficient of variation (CV) | 0.6085298685 |
| Kurtosis | -1.025739123 |
| Mean | 23.64680149 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 0.2622827815 |
| Sum | 19967170 |
| Variance | 207.0659123 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 26 | 20121 | 2.4% |
| 12 | 20099 | 2.4% |
| 9 | 20093 | 2.4% |
| 11 | 20081 | 2.4% |
| 6 | 20068 | 2.4% |
| 5 | 20065 | 2.4% |
| 8 | 20053 | 2.4% |
| 10 | 20051 | 2.4% |
| 4 | 20047 | 2.4% |
| 3 | 20043 | 2.4% |
| Other values (42) | 643671 |
| Value | Count | Frequency (%) |
| 1 | 15161 | |
| 2 | 19448 | |
| 3 | 20043 | |
| 4 | 20047 | |
| 5 | 20065 | |
| 6 | 20068 | |
| 7 | 20041 | |
| 8 | 20053 | |
| 9 | 20093 | |
| 10 | 20051 |
| Value | Count | Frequency (%) |
| 52 | 8319 | |
| 51 | 12355 | |
| 50 | 12333 | |
| 49 | 12334 | |
| 48 | 12334 | |
| 47 | 12182 | |
| 46 | 12333 | |
| 45 | 12334 | |
| 44 | 11042 | |
| 43 | 12361 |
Day
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.83568295 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.683456038 |
|---|---|
| Coefficient of variation (CV) | 0.5483474293 |
| Kurtosis | -1.179690611 |
| Mean | 15.83568295 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.01111712421 |
| Sum | 13371524 |
| Variance | 75.40240876 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 11 | 30121 | 3.6% |
| 4 | 29474 | 3.5% |
| 27 | 29270 | 3.5% |
| 13 | 29262 | 3.5% |
| 23 | 29241 | 3.5% |
| 2 | 29235 | 3.5% |
| 16 | 29203 | 3.5% |
| 18 | 29060 | 3.4% |
| 28 | 28367 | 3.4% |
| 7 | 28359 | 3.4% |
| Other values (21) | 552800 |
| Value | Count | Frequency (%) |
| 1 | 19368 | |
| 2 | 29235 | |
| 3 | 25058 | |
| 4 | 29474 | |
| 5 | 28176 | |
| 6 | 27566 | |
| 7 | 28359 | |
| 8 | 27961 | |
| 9 | 27068 | |
| 10 | 28159 |
| Value | Count | Frequency (%) |
| 31 | 15924 | |
| 30 | 26326 | |
| 29 | 23575 | |
| 28 | 28367 | |
| 27 | 29270 | |
| 26 | 26168 | |
| 25 | 27065 | |
| 24 | 28163 | |
| 23 | 29241 | |
| 22 | 27988 |
IsOpenOnPublicHoliday
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.4 MiB |
| 0 | |
|---|---|
| 1 | 910 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 844392 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 843482 | |
| 1 | 910 | 0.1% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 843482 | |
| 1 | 910 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 843482 | |
| 1 | 910 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 844392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 843482 | |
| 1 | 910 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 844392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 843482 | |
| 1 | 910 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 844392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 843482 | |
| 1 | 910 | 0.1% |
Auto
The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| Store | DayOfWeek | Sales | Promo | SchoolHoliday | StoreType | Assortment | CompetitionDistance | Promo2 | Promo2SinceWeek | Promo2SinceYear | PromoInterval | CompetitionOpenSinceMonth | Year | Season | Month | WeekOfYear | Day | IsOpenOnPublicHoliday | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 5 | 5263 | 1 | 1 | 3 | 1 | 1270.0 | 0 | 23 | 2011 | 0 | 84 | 2015 | 3 | 7 | 31 | 31 | 0 |
| 1 | 1 | 4 | 5020 | 1 | 1 | 3 | 1 | 1270.0 | 0 | 23 | 2011 | 0 | 84 | 2015 | 3 | 7 | 31 | 30 | 0 |
| 2 | 1 | 3 | 4782 | 1 | 1 | 3 | 1 | 1270.0 | 0 | 23 | 2011 | 0 | 84 | 2015 | 3 | 7 | 31 | 29 | 0 |
| 3 | 1 | 2 | 5011 | 1 | 1 | 3 | 1 | 1270.0 | 0 | 23 | 2011 | 0 | 84 | 2015 | 3 | 7 | 31 | 28 | 0 |
| 4 | 1 | 1 | 6102 | 1 | 1 | 3 | 1 | 1270.0 | 0 | 23 | 2011 | 0 | 84 | 2015 | 3 | 7 | 31 | 27 | 0 |
| 5 | 1 | 6 | 4364 | 0 | 0 | 3 | 1 | 1270.0 | 0 | 23 | 2011 | 0 | 83 | 2015 | 3 | 7 | 30 | 25 | 0 |
| 6 | 1 | 5 | 3706 | 0 | 0 | 3 | 1 | 1270.0 | 0 | 23 | 2011 | 0 | 83 | 2015 | 3 | 7 | 30 | 24 | 0 |
| 7 | 1 | 4 | 3769 | 0 | 0 | 3 | 1 | 1270.0 | 0 | 23 | 2011 | 0 | 83 | 2015 | 3 | 7 | 30 | 23 | 0 |
| 8 | 1 | 3 | 3464 | 0 | 0 | 3 | 1 | 1270.0 | 0 | 23 | 2011 | 0 | 83 | 2015 | 3 | 7 | 30 | 22 | 0 |
| 9 | 1 | 2 | 3558 | 0 | 0 | 3 | 1 | 1270.0 | 0 | 23 | 2011 | 0 | 83 | 2015 | 3 | 7 | 30 | 21 | 0 |
Last rows
| Store | DayOfWeek | Sales | Promo | SchoolHoliday | StoreType | Assortment | CompetitionDistance | Promo2 | Promo2SinceWeek | Promo2SinceYear | PromoInterval | CompetitionOpenSinceMonth | Year | Season | Month | WeekOfYear | Day | IsOpenOnPublicHoliday | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 844382 | 1115 | 6 | 4497 | 0 | 0 | 4 | 3 | 5350.0 | 1 | 22 | 2012 | 3 | 55 | 2013 | 1 | 1 | 2 | 12 | 0 |
| 844383 | 1115 | 5 | 5142 | 1 | 1 | 4 | 3 | 5350.0 | 1 | 22 | 2012 | 3 | 55 | 2013 | 1 | 1 | 2 | 11 | 0 |
| 844384 | 1115 | 4 | 5007 | 1 | 1 | 4 | 3 | 5350.0 | 1 | 22 | 2012 | 3 | 55 | 2013 | 1 | 1 | 2 | 10 | 0 |
| 844385 | 1115 | 3 | 4649 | 1 | 1 | 4 | 3 | 5350.0 | 1 | 22 | 2012 | 3 | 55 | 2013 | 1 | 1 | 2 | 9 | 0 |
| 844386 | 1115 | 2 | 5243 | 1 | 1 | 4 | 3 | 5350.0 | 1 | 22 | 2012 | 3 | 55 | 2013 | 1 | 1 | 2 | 8 | 0 |
| 844387 | 1115 | 1 | 6905 | 1 | 1 | 4 | 3 | 5350.0 | 1 | 22 | 2012 | 3 | 55 | 2013 | 1 | 1 | 2 | 7 | 0 |
| 844388 | 1115 | 6 | 4771 | 0 | 1 | 4 | 3 | 5350.0 | 1 | 22 | 2012 | 3 | 54 | 2013 | 1 | 1 | 1 | 5 | 0 |
| 844389 | 1115 | 5 | 4540 | 0 | 1 | 4 | 3 | 5350.0 | 1 | 22 | 2012 | 3 | 54 | 2013 | 1 | 1 | 1 | 4 | 0 |
| 844390 | 1115 | 4 | 4297 | 0 | 1 | 4 | 3 | 5350.0 | 1 | 22 | 2012 | 3 | 54 | 2013 | 1 | 1 | 1 | 3 | 0 |
| 844391 | 1115 | 3 | 3697 | 0 | 1 | 4 | 3 | 5350.0 | 1 | 22 | 2012 | 3 | 54 | 2013 | 1 | 1 | 1 | 2 | 0 |